Data mapping is the process of connecting a data field from one source to a data field in another source. Data Source Mapping can be used to map data and add additional custom Data Columns to a Data Table using formulas, expressions and queries.

Data Mapping / Filtering

Indigo DQM's Data Management Engine (DME) features advanced data mapping, filtering and sorting that can be applied to Data Command Query.

Select the Query tab for the Data Command and check the option to 'Enable Data Mapping / Filtering'.

Enabling Data Mapping

Click the Data Mapping button to open the Data Source Designer for Data Mapping. Select the Table Name from the drop-down list and then add the Data Columns to include and the order in which they should be presented.

Add Data Columns to the Data Mapping and design formulas, expressions and queries accordingly to create the custom data.

Click the OK button to add the Data Column to the Data Source Mapping.

Enabling Data Filtering and Sorting

Data Filters can be applied to Data Mapping for filtering and sorting.

To enable Data Filtering click the Data Filter (...) property button to open the filter properties page or use the Data Filter Designer.

For example, if a Select Filter is applied for Name = 'Cool Doc Fee' then only the Fees with this criteria will be returned. Also, additional sorting can be applied to the Data Command Query to sort results by specific Data Column(s).

Data Row Limit

The number of Data Rows in the Data Table can be limited by specifying a Row Limit. Open the property page for the Data Filter and enter a limit for the Data Rows.

Data Distinct Values

Data Distinct determines how data is summarized with special functions for summarising data by Sum, Average, Count, Max, Min, First, Last and Exists.

Enable Distinct Values and choose the relevant Data Column(s) and function for the Data Table according to how the Data needs to be summarised or presented.

Data Filter Designer

The Data Filter Designer is a powerful tool to help with the design and application of Data Filters and Data Sorting on Data Columns.

Select the Data Columns to filter and / or sort from the drop-down lists.

Click the 'Execute' button to apply the Data Filter and view the filtered Data. Click OK to apply the Data Filter to the Data Command Query.

Data Manipulators

Data Manipulators provides methods to prepare and manipulate data for technical analysis, apply formulas on the data and prepare output data.

Advanced formulas and financial analysis such as forecasting can be used to output forecast data and trends.

Sorting, grouping and filtering operations can also be applied using multiple data manipulators.